/**
 * permission表操作 
 */
var MenuData = {
    // 按照角色类型查询权限数据
    queryPerData: function(param) {
        return "select * from menu a left join permission b on a.ID = b.MID where b.RID = '"+param.rid+"';"; 
    },
    // 删除ID对应的数据
    deleteData: function(param) {
        return "DELETE from permission where ID = " + param.id;
    },
    // 增加数据
    insertData: function(param) {
        return "INSERT INTO permission set MID = '"+param.mid+"' , RID = '"+ param.rid+"';";
    },
}
exports = module.exports = MenuData;